Print labels for SKU and catalog numbers in a spreadsheet

When to use this procedure

Use this procedure to print labels for SKU and catalog numbers that are saved in a Microsoft Excel spreadsheet. The spreadsheet must have two columns. Column A must be the SKU or catalog number and Column B must be the location. AIMsi will print labels for each SKU/catalog number in the spreadsheet.

Steps to complete

Prerequisites: You must have barcode label defaults set up and you must have a barcode label printer set up for the workstation where you will print barcodes.

  1. On the Print Barcode Labels window, File tab, click Browse and navigate to the location on your computer where your Microsoft Excel file is saved.
  2. Select Print One Label Per Sku or Print Quantity On Hand.
  3. Select Exclude Zero Qty Items to print labels only for items with a quantity higher than 0.
  4. Select Print Labels for MFG Barcoded Items if you want to print labels for inventory items that are, and are not, pre-barcoded by the manufacturer.
  5. Click Print.

Helpful links

Print barcode labels

There are no related reports.

There are no related variables.

Barcode and barcode label general overview

Print Barcode Labels window